womenadverseeventvaccinationdetails
Table: womenadverseeventvaccinationdetails
The womenadverseeventvaccinationdetails table stores vaccination details linked to a woman’s adverse event.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| womenAdverseEventVaccinationDetailsId | int(11) | NO | Primary key identifying the vaccination detail record |
| createdDate | datetime | YES | Timestamp when the record was created |
| lastEditedDate | datetime | YES | Timestamp when the record was last edited |
| batchNo | varchar(255) | YES | Vaccine batch number |
| expiryDate | datetime | YES | Expiration date of the vaccine |
| manufacturerName | varchar(255) | YES | Name of the vaccine manufacturer |
| vaccineId | int(11) | YES | Reference to the vaccine used |
| womenAdverseEventId | int(11) | YES | Reference to the related adverse event |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
| dateManufacture | datetime | YES | Manufacturing date of the vaccine |
| serialNo | varchar(255) | YES | Serial number of the vaccine |
Indexes
- Primary key on
womenAdverseEventVaccinationDetailsId
Foreign Key Relations
womenAdverseEventId → womenadverseevent.womenAdverseEventId
Usage Notes
- Stores detailed vaccine information related to adverse events.
- Useful for batch tracking and quality investigations.